# -*- coding:utf-8 -*-
"""
Author：Administrator
Date:2021年10月14日
"""
import pandas as pd

path = '../数据文件/课件030-031/环比.xlsx'

data = pd.read_excel(path, sheet_name='Sheet1')

last_month= data.销售金额.shift()

chain_rele = data.销售金额 - last_month

data['环比增长金额'] = chain_rele

print(data)